Release 10.1A: OpenEdge Development:
Progress Dynamics Advanced Development

Enabling SDF-level caching

Dynamics supports a type of behind-the-scenes caching for dynamic combos. The result set of the database query for the SmartDataField is kept in one temp-table, and another temp-table manages the subsets of this data being used in each instance of the combo. It improves performance by ensuring each instance does not need to store the entire database result set.

To enable this type of caching for a dynamic combo:

Select Build Smart Data Field Maintenance, as shown:



Make sure the Data source option button has Database query selected.
Enable the Use cache option, which is actually enabled by default.
Save and exit.